package mypage;

import common.db.*;
import common.main.*;

public class OrderInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");
		String seq = (String)inputTable.get("seq");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT a.NAME TITLE, a.SEQ, a.AMOUNT, a.PRICE, a.REG_ID, a.REG_DATE, c.STEP, d.DELIVERY_STATE, e.NAME name ");
		queryBuffer.append("FROM ORDERLIST a, MAGIC b, ORDER_STATE c, DELIVERY_STATE d, MEMBER e ");
		queryBuffer.append("WHERE a.SEQ='"+ seq +"' AND b.ORDER_STATE = c.SEQ AND b.DELIVERY_STATE = d.SEQ AND e.id='"+ id +"'");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}


